﻿CREATE TABLE [dbo].[VacantElectorateOffices] (
    [AddressLine1]    NVARCHAR (100) NULL,
    [AddressLine2]    NVARCHAR (100) NULL,
    [Suburb]          NVARCHAR (50)  NULL,
    [State]           NVARCHAR (4)   NULL,
    [PostCode]        NVARCHAR (4)   NULL,
    [PrincipalOffice] BIT            NULL,
    [Telephone]       NVARCHAR (50)  NULL,
    [Fax]             NVARCHAR (50)  NULL,
    [PostalAddress]   NVARCHAR (100) NULL,
    [PostalSuburb]    NVARCHAR (50)  NULL,
    [PostalState]     NVARCHAR (4)   NULL,
    [PostalPostCode]  NVARCHAR (4)   NULL,
    [Id]              INT            IDENTITY (1, 1) NOT NULL,
    [TollFreePhone]   NVARCHAR (50)  NULL,
    [Electorate_Id]   INT            NOT NULL
);

